Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners
ICTWEB425 Mapping and Delivery Guide
Apply structured query language to extract and manipulate data
Version 1.0
Issue Date: May 2024
Qualification | - |
Unit of Competency | ICTWEB425 - Apply structured query language to extract and manipulate data |
---|---|---|---|
Description | |||
Employability Skills | |||
Learning Outcomes and Application | This unit describes the skills and knowledge required to produce structured query language (SQL) statements to work with server-side scripts, enabling web designers to interact with web server databases.It applies to individuals who are employed as web designers responsible for creating server-side interaction with dynamic web pages, using SQL as a means of communicating with the database.No licensing, legislative or certification requirements apply to this unit at the time of publication. | ||
Duration and Setting | X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting. Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the website technologies field of work, and include access to: a development environment a database server. Assessors must satisfy NVR/AQTF assessor requirements. |
||
Prerequisites/co-requisites | |||
Competency Field |
Development and validation strategy and guide for assessors and learners | Student Learning Resources | Handouts Activities |
Slides PPT |
Assessment 1 | Assessment 2 | Assessment 3 | Assessment 4 | |
---|---|---|---|---|---|---|---|---|
Elements of Competency | Performance Criteria | |||||||
Element: Identify SQL requirements from the specification documentation |
| |||||||
Element: Create a relational database |
| |||||||
Element: Test SQL results |
|